Linked Servers

A linked server configuration enables SQL Server to execute commands against OLE DB data sources on remote servers. Linked servers offer the following advantages:

Note: SQL Azure does not support.

Just simply click -> Linked Server to open an object pane for Linked Server. A control-click displays the popup menu or using the object pane toolbar below, allowing you to create new, edit and delete the selected linked server.

Create Linked Server

To create a new linked server

To create a new linked server with modification as one of the existing linked server

Edit Linked Server

To edit the existing linked server(manage its general etc)

Test Linked Server

To test the existing linked server

Delete Linked Server

To delete a linked server

Achieve Linked Server Information

To achieve a linked server information